package cemp.mapper;

import cemp.entity.StockKpiDay;
import cemp.entity.StockPlate;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author xsb_t
* @description 针对表【stock_plate】的数据库操作Mapper
* @createDate 2024-11-06 00:57:08
* @Entity cemp.mybatis.entity.StockPlate
*/
public interface StockPlateMapper extends BaseMapper<StockPlate> {


    @Select("select t2.name ,t2.flag from stock_plate_stocks t1 join stock_plate t2 on t1.platecode = t2.platecode where t1.stock_code = #{stockCode}")
    List<StockPlate> getPlatesByCode(@Param("stockCode")String stockCode);
}




